#!/bin/sh
#-- set var ---------
export ORACLE_SID=PROD
export ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin

#-----get tablespace Usage info -----------
#-----get segment size gt 100m  info ------
sqlplus /nolog<< EOF
conn / as sysdba
set echo off
set serveroutput off
@/home/oracle/scripts/monitor_tblspace.sql
@/home/oracle/scripts/monitor_segment.sql
exit
EOF

